Suspended Tables
When a table is suspended, information about the table including the reason for its suspension is recorded in the attrep_suspended_tables
table. If a table is suspended and then unsuspended while the task is running, the entries for that table will be deleted from the attrep_suspended_tables
table.
When a task with suspended tables stops, records for that task will remain in the attrep_suspended_tables
table. In the event that the tables are still suspended when the task is restarted, the data is deleted and then recorded again.
Column | Type | Description |
---|---|---|
SERVER_NAME |
nvchar |
The name of the machine on which Replicate is installed. |
TASK_NAME |
nvchar |
The name of the Replicate task. |
TABLE_OWNER |
nvchar |
The owner of the suspended table. |
TABLE_NAME |
nvchar |
The name of the suspended table. |
SUSPEND_REASON |
varchar |
The reason why the table was suspended. |
SUSPEND_TIMESTAMP |
timestamp |
The date and time the table was suspended. |